package com.wangsd.web.shop.mapper;

import com.gitee.fastmybatis.core.mapper.CrudMapper;
import com.wangsd.web.shop.entity.Coupon;
import com.wangsd.web.shop.entity.CouponOrder;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface CouponOrderMapper extends CrudMapper<CouponOrder, Long> {
    @Select("select * from coupon_order where  created_time < (select date_sub(NOW(), interval 1 MINUTE)) and status=0")
    List<CouponOrder> selectByStatus();
}
